Configuring Service.props

If set to Y, the secondary user validation is bypassed. If not, secondary user validation is performed.

(Optional) – The path to the JDBC driver. If the default CLASSPATH used when the Adapter process is started does not include an appropriate JDBC driver jar required to connect to the PowerCenter Repository Database, you will need to specify this service.props configuration

Setting this flag to Y allows synchronous connections without overloading the RDOnly Thread. If set to N, the adapter might stop trying to reconnect after an outage or downtime.

Setting this flag to Y avoids an unnecessary logout call to the Informatica server when the connection is lost. This logout call usually hangs.

Use to avoid frequent polling on long-running jobs. When set to Y in service.props of a particular adapter, these properties are enabled:
MinDynamicPollInterval – Minimum value should be 5 seconds.
MaxDynamicPollIntervalInMin – Maximum value should be 5 minutes.
PercentOfEstDuration – Default value is 5.

Make sure that the Hadoop environment contains the Java version the TA Master is running on.

This parameter can be set in service.props, job configuration and connection configuration parameters. The order of precedence is service.props (applicable for all jobs running in all connections), job level (only for that particular job), and connection (applicable for all jobs in the connection). This parameter is used to specify Informatica-specific error codes, separated by commas (,), that you want to ignore while running a job.

Y or N. Setting this flag to Y stops huge job xml file transfers back and forth between the adapter and the AdapterHost during polls when a single request set has multiple sub-requests of more than 100. The default value is N or empty.

If the Hadoop cluster is Kerberos secured, use this value to specify the KDC Server. For example, kerbkdc=172.25.6.112

If the Hadoop cluster is Kerberos secured, use this value to specify the Kerberos Realm.

For example, kerbrealm=TIDALSOFT.LOCAL

Specify

Keystore=c:\\<adapter_certificate_directory>\\<your_trusted_keystore>.keystore when importing certificates into a Java keystore.

This parameter can be set in service.props, job configuration and connection configuration parameters. The order of precedence is service.props (applicable for all jobs running in all connections), job level (only for that particular job), and connection (applicable for all jobs in the connection). If a non-zero value is set for this parameter, then the jobs are delayed for the specified number of milliseconds before being submitted to Informatica.

Specifies the location of the login configuration if using WinAD or LDAP authentication. For example:

LoginConfig=c:\\windows\\bscLogin.conf

where “c:\\windows\\bscLogin.conf” is the location of the login configuration information. Note the use of \\ if this is a Windows location.

(Optional) – Number of logs to retain.

Setting this flag to Y avoids jobs getting stuck in Gathering Output status.

Enables concurrent output gathering on a connection. To enable this feature, set the value to N.

Enables concurrent polling on connections of the same type. This is helpful when there is a heavily load on one connection of an adapter. The heavily loaded connection will not affect the other adapter connection. To enable this feature, set the value to N.

Y or N. If set to Y, the timeout value defined using the parameter QUERY_TIMEOUT_VALUE is applied to the SQL queries. Default value is N or empty.

The time period in seconds that SQL queries wait before timeout. If 0 or not set, there is no timeout.

Used to control the log gathering in SAP Process Chain jobs. This property depends on the Summary Only checkbox of the job definition Options tab.

Y or N – Set this parameter to N to turn off the default behavior of Informatica jobs collecting the session statistics during the job run.

Y or N – Set this parameter to Y to turn off the gathering of session statistics during each poll for the status of Informatica jobs.

Points to the Load Manager Library locale directory. See “Configuring the Informatica Adapter” in the Informatica Adapter Guide for how to set this for Windows and Unix environments.

(Optional) – The number of seconds before an API request times out. The default is 120 seconds, if not specified.

(Windows only, optional) An alternate path to the JDBC library files. The library file path should have been configured given system environment variables. This option is available in case you wish to use an alternate set of libraries and may be helpful for trouble-shooting purposes.

The path to the JDBC locale files.

Set this parameter if more than 5000 lines need to be read from the transaction table.